How to: Manually format each data series in a chart as a different chart type.
Solution:
Select the data series and select 'Chart Type...' from the 'Format' menu.
1) Select the desired chart:
a) If the chart is embedded on the worksheet, double-click on the chart. (A striped border with handles appears around the chart.)
b) If the chart is on a separate chart sheet, click the tab for the chart sheet.
2) Select (click once on) the data series to format.
3) Select the 'Format' menu and select 'Chart Type...'. (The Chart Type dialog box appears.)
Chart Type dialog box
4) Select the 'Selected Series' radio button from the 'Apply to' group.
5) Select the appropriate type of dimension in the 'Chart Dimension' group.
NOTE: Different types of dimension cannot exist in the same chart simultaneously. For example, a 2-D data series cannot be combined with a 3-D data series in a chart.
6) (Optional) Select the picture representing the desired chart format.
7) Click 'OK'.
